﻿ALTER TABLE esf_sso.BasicReference DROP CONSTRAINT FK_BasRef_BasRefType_Type;
ALTER TABLE esf_sso.[User] DROP CONSTRAINT FK_User_Person_Person;
ALTER TABLE esf_sso.Person DROP CONSTRAINT FK_Per_BasRef_Gender;
ALTER TABLE esf_sso.Person DROP CONSTRAINT FK_Per_BasRef_IdentificationType;
ALTER TABLE esf_sso.Location DROP CONSTRAINT FK_PerLoc_BasRefCity;
ALTER TABLE esf_sso.Enterprise DROP CONSTRAINT FK_Ent_BasRef_IdentificationType;
ALTER TABLE esf_sso.Person DROP CONSTRAINT FK_Per_Ent_Enterprise;
ALTER TABLE esf_sso.UserSessionLog DROP CONSTRAINT FK_USLog_Usr_User;
ALTER TABLE esf_sso.[User] DROP CONSTRAINT FK_Usr_BasRef_SecurityQuestion;
ALTER TABLE esf_sso.Enterprise DROP CONSTRAINT FK_Ent_BasRef_Enterprise;
ALTER TABLE esf_sso.User_BasicReference DROP CONSTRAINT FK_User_BasRef_BasRef;
ALTER TABLE esf_sso.User_BasicReference DROP CONSTRAINT FK_User_BasicReference_User;
ALTER TABLE esf_sso.ContactUs DROP CONSTRAINT FK_ConUs_BasRef_Application;
ALTER TABLE esf_sso.TreeBasicReferenceValue DROP CONSTRAINT FK_TreeBasRef_TreeBasRefValue;
DROP TABLE esf_sso.TreeBasicReferenceValue;
ALTER TABLE esf_sso.TreeBasicReference DROP CONSTRAINT FK_TreeBasRef_BasRef;
ALTER TABLE esf_sso.TreeBasicReference DROP CONSTRAINT FK_TreeParBasRef_BasRef;
ALTER TABLE esf_sso.Location DROP CONSTRAINT FK_PerLoc_BasRefCountry;
ALTER TABLE esf_sso.Person_Location DROP CONSTRAINT FK_Lct_PerLct;
ALTER TABLE esf_sso.Person_Location DROP CONSTRAINT FK_Per_PerLct;
ALTER TABLE esf_files.[File] DROP CONSTRAINT FK_BasRef_File_FileType;
ALTER TABLE esf_sso.BasicReference_File DROP CONSTRAINT FK_File_BasRefFile;
ALTER TABLE esf_sso.BasicReference_File DROP CONSTRAINT FKBasicRefer932173;
ALTER TABLE esf_sso.BasicReference_Location DROP CONSTRAINT FK_BasRef_BasRefLoc;
ALTER TABLE esf_sso.BasicReference_Location DROP CONSTRAINT FK_Loc_BasRefLoc;
ALTER TABLE esf_sso.User_BasicReference_Values DROP CONSTRAINT FK_BasRef_BasRefValues;
ALTER TABLE esf_sso.User_BasicReference_Values DROP CONSTRAINT FK_Usr_BasRefValues;
DROP TABLE esf_sso.Person;
DROP TABLE esf_sso.BasicReference;
DROP TABLE esf_sso.BasicReferenceType;
DROP TABLE esf_sso.[User];
DROP TABLE esf_sso.Location;
DROP TABLE esf_sso.Enterprise;
DROP TABLE esf_sso.UserSessionLog;
DROP TABLE esf_sso.User_BasicReference;
DROP TABLE esf_sso.ContactUs;
DROP TABLE esf_sso.TreeBasicReference;
DROP TABLE esf_sso.Person_Location;
DROP TABLE esf_files.[File];
DROP TABLE esf_sso.BasicReference_File;
DROP TABLE esf_sso.BasicReference_Location;
DROP TABLE esf_sso.User_BasicReference_Values;